﻿CREATE PROCEDURE [dbo].[Person_Select]
@PersonID uniqueidentifier
AS
BEGIN

SELECT [PersonID]
, [CreatedDate]
, [CreatedBy]
, [ModifiedDate]
, [ModifiedBy]
, [Deleted]
, [GenderID]
, [RaceID]
, [ResidentialAddressID]
, [ContactDetailID]
, [IdentityTypeID]
, [FirstName]
, [MiddleName]
, [Surname]
, [Initials]
, [IdentityNumber]
, [DateOfBirth]
, [Age]
FROM [dbo].[Person] (NoLock)
WHERE [Deleted] = 0
AND [PersonID] = @PersonID


END
